Application.yaml

The conf folder will have application.yaml file which consists of application-level properties and data source connection details.

The properties should be changed accordingly.

Server Port#

The server port# should be unique and unused by any other process in the system.

Server Port Number

server:

port: 6060

Batch size

The batch size represents number of records to be processed by a single batch, default value is 100, its value should not exceed 1000.

The thread pool size represents number of entities to be processed parallelly in a single batch, default value is 10.

app batch size

app:

batchSize: 100

threadpoolSize: 10

The default data base type in application.yaml is Oracle, and MSSQL.

Do not change the driver class.

Database details

Oracle

For Oracle Database, please uncomment the section below by removing the '#' symbols and update the following values according to your environment:

hostname, port, service name, username, password.

#database:
#  type: Oracle
#  driverClass: oracle.jdbc.driver.OracleDriver
#javax:
#  sql:
#    DataSource:
#      ARCHIVESSOURCE:
#        dataSourceClassName: oracle.jdbc.pool.OracleDataSource
#        dataSource:
#          URL: jdbc:oracle:thin:@hostname:port:servicename
#          user: username
#          password: password
#      ARCHIVESTARGET:
#        dataSourceClassName: oracle.jdbc.pool.OracleDataSource
#        dataSource:
#          URL: jdbc:oracle:thin:@hostname:port:servicename
#          user: username
#          password: password

MS SQL server

For MSSQL Server Database, please uncomment the section below by removing the '#' symbols and update the following values according to your environment:

hostname, port, databasename, username, password.

#database:
#  type: SQLServer
#  driverClass: com.microsoft.sqlserver.jdbc.SQLServerDriver
#javax:
#  sql:
#    DataSource:
#      ARCHIVESSOURCE:
#        dataSourceClassName: com.microsoft.sqlserver.jdbc.SQLServerDataSource
#        dataSource:
#          URL: jdbc:sqlserver://hostname:port;databasename=databaseName;encrypt=false;trustServerCertificate=true
#          user: username
#          password: password
#      ARCHIVESTARGET:
#        dataSourceClassName: com.microsoft.sqlserver.jdbc.SQLServerDataSource
#        dataSource:
#          URL: jdbc:sqlserver://hostname:port;databasename=databaseName;encrypt=false;trustServerCertificate=true
#          user: username
#          password: password

DB2 Database

For DB2 Database, please uncomment the section below by removing the '#' symbols and update the following values according to your environment:

hostname, port, databaseName, currentSchema, user, password, portNumber.

Schema name needs to be added to the Db2 Function path. Execute the below to get the current path and add the schema name to it.

Get Current Function Path

SELECT CURRENT_PATH FROM SYSIBM.SYSDUMMY1;

-- Below is the sample output

"SYSIBM","SYSFUN","SYSPROC","SYSIBMADM","username"

--Add currentSchemaName to the above current function path as following.

currentFunctionPath=SYSIBM,SYSFUN,SYSPROC,SYSIBMADM,SYSHADOOP,username,currentSchemaName;

Database details - DB2

#database:
#  type: DB2
#  driverClass: com.ibm.db2.jcc.DB2Driver
#  sourceURL: jdbc:db2://hostname:port/databaseName:currentSchema=currentSchemaName;currentFunctionPath=SYSIBM,SYSFUN,SYSPROC,SYSIBMADM,SYSHADOOP,username,currentSchemaName;
#  targetURL: jdbc:db2://hostname:port/databaseName:currentSchema=currentSchemaName;currentFunctionPath=SYSIBM,SYSFUN,SYSPROC,SYSIBMADM,SYSHADOOP,username,currentSchemaName;
#javax:
#  sql:
#    DataSource:
#      ARCHIVESSOURCE:
#        dataSourceClassName: com.ibm.db2.jcc.DB2SimpleDataSource
#        dataSource:
#          user: username
#          password: password
#          databaseName: databaseName
#          serverName: hostName
#          portNumber: portNumber
#          currentSchema: currentSchema
#          driverType: 4
#          progressiveStreaming: 2
#      ARCHIVESTARGET:
#        dataSourceClassName: com.ibm.db2.jcc.DB2SimpleDataSource
#        dataSource:
#          user: username
#          password: password
#          databaseName: databaseName
#          serverName: hostName
#          portNumber: portNumber
#          currentSchema: currentSchema
#          driverType: 4
#          progressiveStreaming: 2